//read in nsly97 geocode to get age-17 state and colleges attended.

global nlsy "V:\Anstreicher_RIM\NLSY97\NLSY97 data\NLSY97_Geocode_1997-2015\Geocode"

//location
import delimited "$nlsy/Location/Location_R17.csv", clear
ren *, upper
do "$nlsy/Location/Location_R17-value-labels"
ren *, lower
ren pubid uniqid
keep uniqid geo02*
drop geo02_age12
forval y = 1997/2015{
    cap ren geo02_`y' stfips_`y'
}
save "$temp/nlsy_states", replace

//education
import delimited "$nlsy/Education/Education_R17.csv", clear
ren *, upper
do "$nlsy/Education/Education_R17-value-labels"
ren *, lower
ren pubid uniqid
keep uniqid geo69_01* geo70_01*

//renaming
forval y = 1997/2015{
    cap ren geo69_01_`y' coll_unitid_`y'
	cap ren geo70_01_`y' coll_stfips_`y'
}

save "$temp/nlsy_geocode_educ", replace






//end of dofile